# -*- coding: utf-8 -*-

#需要处理的excel文件
_EXCEL_FILE_PATH_ = "副本新增英文分销关.xlsx"

#需要处理的sheet表 如果是所有,使用[]
_EXCEL_SHEET_INDEX_ = []

def GetVal(i, v):
    if i == 3:
        if v == "子酒店":
            return "0"
        return "1"
    if i == 1:
        return int(v)
    return str(v)

##_SQL_FORMAT_ = "DELETE FROM dbo.Htl_BlackList WHERE NameListType = 1 AND NameListValue = '${1}' AND IsMasterHotel = ${3} ;"
## _SQL_FORMAT_ = "INSERT INTO dbo.Htl_BlackList (NameListType, NameListValue,IsMasterHotel,Status,DataChange_LastTime,DataChange_CreateTime,DataOperator) VALUES (1,'${1}',${3},1,getdate(),getdate(),'op1');"

_SQL_FORMAT_ = "SELECT * FROM dbo.Htl_BlackList WHERE NameListType = 1 AND NameListValue = '${1}' AND IsMasterHotel = ${3} ;"


